using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Globalization;

/* =====================================================================

  File:      for Adventure Works Cycles Storefront Sample
  Summary:   Displays a brief summary of all products of the selected subcategory
  Date:	     June 16, 2003

---------------------------------------------------------------------

  This file is part of the Microsoft SQL Server Code Samples.
  Copyright (C) Microsoft Corporation.  All rights reserved.

This source code is intended only as a supplement to Microsoft
Development Tools and/or on-line documentation.  See these other
materials for detailed information regarding Microsoft code samples.

THIS CODE AND INFORMATION ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY
KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE
IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A
PARTICULAR PURPOSE.

======================================================= */

namespace Microsoft.Samples.SqlServer {

    public partial class ProductsList : System.Web.UI.Page
    {

    
//         public ProductsList() {
//             Page.Init += new System.EventHandler(Page_Init);
//         }

        //*******************************************************
        //
        // The Page_Load event on this page is used to obtain
        // from a database a collection of all products within a
        // specified product category.  The collection is then
        // databound to a templated asp:datalist control.
        //
        // The product category to obtain is specified using
        // a querystring argument to the page.
        //
        // Note that this page is output cached at 1 hour
        // intervals.  This eliminates the need to hit the database
        // on each request to the page.
        //
        //*******************************************************

        private void Page_Load(object sender, System.EventArgs e) {

            // Obtain categoryId from QueryString
            int subCategoryId = Int32.Parse(Request.Params["SubcategoryID"], CultureInfo.InvariantCulture);



            // Obtain products and databind to an asp:datalist control
            ProductsDB productCatalogue = new ProductsDB();
        
            MyList.DataSource = productCatalogue.GetProducts(subCategoryId);
            MyList.DataBind();
			
        }

        private void Page_Init(object sender, EventArgs e) {
            //
            // CODEGEN: This call is required by the ASP.NET Web Form Designer.
            //
            InitializeComponent();
        }

		#region Web Form Designer generated code
        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent() {
		}
		#endregion

    }
}
